Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
CREATED_DATE DATE Yes null 37 null NO NO NO
CREATED_ON_FY NUMBER Yes null 38 null NO NO NO
LAST_MODIFIED_DATE DATE Yes null 39 null NO NO NO
TIME_TO_INVESTIGATIVELY_CLOSED_DAYS NUMBER(38) Yes null 40 null NO NO NO
OFFICE VARCHAR2(4000) Yes null 41 null NO NO NO
SID NUMBER No null 1 null NO NO NO
OBJ VARCHAR2(20) No null 2 null NO NO NO
ID VARCHAR2(100) No null 3 null NO NO NO
TITLE VARCHAR2(100) No null 4 null NO NO NO
OBJ_TYPE VARCHAR2(100) No null 5 null NO NO NO
ALLEGATION_CATEGORY VARCHAR2(200) Yes null 6 null NO NO NO
ALLEGATION_SUBCATEGORY VARCHAR2(200) Yes null 7 null NO NO NO
CONTRIBUTING_FACTOR VARCHAR2(200) Yes null 8 null NO NO NO
POLICY_REVIEW VARCHAR2(400) Yes null 9 null NO NO NO
CASE_DISPOSITION VARCHAR2(4000) Yes null 10 null NO NO NO
AGENCY_CASE_NUM VARCHAR2(30) Yes null 11 null NO NO NO
INV_AUTHORIZATION VARCHAR2(4000) Yes null 12 null NO NO NO
SUBJECTS VARCHAR2(4000) Yes null 13 null NO NO NO
OWNING_AGENCY VARCHAR2(4000) Yes null 14 null NO NO NO
STATUS VARCHAR2(100) Yes null 15 null NO NO NO
OPEN_DATE DATE Yes null 16 null NO NO NO
OPEN_DATE_FY NUMBER Yes null 17 null NO NO NO
OVERALL_CLOSED_DATE DATE Yes null 18 null NO NO NO
CLOSED_DATE DATE Yes null 19 null NO NO NO
CLOSED_DATE_FY NUMBER Yes null 20 null NO NO NO
CLOSED_NI_DATE DATE Yes null 21 null NO NO NO
CLOSED_NI_FY NUMBER Yes null 22 null NO NO NO
INV_CLOSED_DATE DATE Yes null 23 null NO NO NO
INV_CLOSED_DATE_FY NUMBER Yes null 24 null NO NO NO
DAYS_OPEN NUMBER(38) Yes null 25 null NO NO NO
LEAD_PERSONNEL VARCHAR2(400) Yes null 26 null NO NO NO
SUPPORT_PERSONNEL VARCHAR2(4000) Yes null 27 null NO NO NO
INCIDENT_DATE DATE Yes null 28 null NO NO NO
INCIDENT_DATE_FY NUMBER Yes null 29 null NO NO NO
INCIDENT_LOCATION VARCHAR2(4000) Yes null 30 null NO NO NO
REPORTED_DATE DATE Yes null 31 null NO NO NO
REPORTED_DATE_FY NUMBER Yes null 32 null NO NO NO
NEXT_DUE_DATE DATE Yes null 33 null NO NO NO
FINAL_DUE_DATE DATE Yes null 34 null NO NO NO
FINAL_DUE_DATE_FY NUMBER Yes null 35 null NO NO NO
FINAL_DUE_DATE_MET VARCHAR2(3) Yes null 36 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE



References


NAME VALUE
CREATED 03-FEB-25
LAST_DDL_TIME 05-FEB-25
OWNER QART
VIEW_NAME V_CUBE_SIII_INVESTIGATIONS
TEXT_LENGTH 5293
TEXT SELECT DISTINCT           I.SID,           I.OBJ,           I.ID,           I.SUBJECT TITLE,           OT.DISPLAY OBJ_TYPE,           C.DISPLAY ALLEGATION_CATEGORY,           SC.DISPLAY ALLEGATION_SUBCATEGORY,           F.DISPLAY CONTRIBUTING_FACTOR,           I.POLICY_VIOLATION POLICY_REVIEW,           IR.DISPLAY CASE_DISPOSITION,           I.AGENCY_CASE_NUM,           I.INV_AUTHORIZATION,           SUB.SUBJECTS,           OA.OWNING_AGENCY,           STAT1.STATUS,           TRUNC (STAT2.STARTED_ON) OPEN_DATE,           STAT2.STARTED_ON_FY OPEN_DATE_FY,           TRUNC(STAT6.STARTED_ON) OVERALL_CLOSED_DATE,           TRUNC (STAT3.STARTED_ON) CLOSED_DATE,           STAT3.STARTED_ON_FY CLOSED_DATE_FY,           TRUNC(STAT5.STARTED_ON) CLOSED_NI_DATE,           STAT5.STARTED_ON_FY CLOSED_NI_FY,   TRUNC (STAT4.STARTED_ON) INV_CLOSED_DATE,           STAT4.STARTED_ON_FY INV_CLOSED_DATE_FY,           (TRUNC (NVL (STAT6.STARTED_ON, SYSDATE)) - TRUNC (STAT2.STARTED_ON))              DAYS_OPEN,           SH1.SH_DISPLAY LEAD_PERSONNEL,           SH2.SH_DISPLAY SUPPORT_PERSONNEL,           I.INCIDENT_DATE,           I.INCIDENT_DATE_FY,   R1.DISPLAY INCIDENT_LOCATION,           I.REPORTED_DATE,           I.REPORTED_DATE_FY,           O.NEXT_DUE_DATE,           O.FINAL_DUE_DATE,           O.FINAL_DUE_DATE_FY,           CASE              WHEN TRUNC (STAT3.STARTED_ON) <= TRUNC (O.FINAL_DUE_DATE)              THEN                 'Yes'              ELSE                 'No'           END              FINAL_DUE_DATE_MET,           O.CREATED_ON CREATED_DATE,           O.CREATED_ON_FY CREATED_ON_FY,           O.LAST_MODIFIED_ON LAST_MODIFIED_DATE,          (TRUNC (NVL (STAT4.STARTED_ON, SYSDATE)) - TRUNC (O.CREATED_ON))              TIME_TO_INVESTIGATIVELY_CLOSED_DAYS,           SUB.OFFICE         FROM MV_F_INFORMATION I           INNER JOIN MV_ACM_OBJ O              ON I.OBJ = O.SID           INNER JOIN MV_ACM_OBJ_TYPE OT              ON O.OBJ_TYPE = OT.SID              AND OT.OBJ_TYPE_CODE != 'FILE.COLL_INV'           LEFT JOIN MV_INCIDENT_CATEGORIES SC              ON I.INCIDENT = SC.SID           LEFT JOIN MV_INCIDENT_CATEGORIES C              ON SC.PARENT_CATEGORY = C.SID           LEFT JOIN MV_CONTRIBUTING_FACTORS F              ON I.CONTRIBUTING_FACTOR = F.SID           LEFT JOIN MV_F_INFORMATION_REF IR              ON I.DISPOSITION = IR.REF_KEY           LEFT JOIN MV_ACM_REFERENCE R1             ON I.INCIDENT_LOCATION = R1.REF_KEY           LEFT JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (PARTIC_OBJ, ';' || CHR (13)) WITHIN GROUP (ORDER BY PARTIC_OBJ) OVER (PARTITION BY OBJ)                                AS SUBJECTS,                             LISTAGG(OFFICE,';' || CHR (13)) WITHIN GROUP ( ORDER BY PARTIC_OBJ ) OVER (PARTITION BY OBJ) AS OFFICE                        FROM V_OBJ_PARTICIPANTS                       WHERE CODE = 'SUBJECT') SUB              ON I.OBJ = SUB.OBJ           LEFT JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (PARTIC_DISPLAY, ';' || CHR (13))                                WITHIN GROUP (ORDER BY PARTIC_DISPLAY)                                OVER (PARTITION BY OBJ)                                AS OWNING_AGENCY                        FROM V_OBJ_PARTICIPANTS                       WHERE CODE = 'OWNING_AGENCY') OA              ON I.OBJ = OA.OBJ           LEFT JOIN V_OBJ_STATUS_HISTORY STAT1              ON I.OBJ = STAT1.OBJ AND STAT1.COMPLETED_ON IS NULL           LEFT JOIN (  SELECT OBJ,                               MIN (STARTED_ON) STARTED_ON,                               MIN (STARTED_ON_FY) STARTED_ON_FY                          FROM V_OBJ_STATUS_HISTORY                         WHERE CODE = 'OPEN'                      GROUP BY OBJ) STAT2              ON I.OBJ = STAT2.OBJ           LEFT JOIN V_OBJ_STATUS_HISTORY STAT3              ON I.OBJ = STAT3.OBJ AND STAT3.CODE LIKE 'CLOSED'   LEFT JOIN (  SELECT OBJ,                               MIN (STARTED_ON) STARTED_ON,                               MIN (STARTED_ON_FY) STARTED_ON_FY                          FROM V_OBJ_STATUS_HISTORY                         WHERE CODE = 'INV_CLOSED'                      GROUP BY OBJ) STAT4              ON I.OBJ = STAT4.OBJ           LEFT JOIN V_OBJ_STATUS_HISTORY STAT5              ON I.OBJ = STAT5.OBJ AND STAT5.CODE LIKE 'CLOSED_NI'           LEFT JOIN (  SELECT OBJ,                               MIN (STARTED_ON) STARTED_ON                          FROM V_OBJ_STATUS_HISTORY                         WHERE CODE in ('CLOSED','CLOSED_NI','INV_CLOSED')                             -- AND STARTED_ON > '01-SEP-22'                      GROUP BY OBJ) STAT6              ON I.OBJ = STAT6.OBJ           LEFT JOIN V_CURR_OBJ_STAKEHOLDERS SH1              ON I.OBJ = SH1.OBJ AND SH1.CODE = 'LEAD'           LEFT JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (SH_DISPLAY, ';' || CHR (13))                                WITHIN GROUP (ORDER BY SH_DISPLAY)                                OVER (PARTITION BY OBJ)                                AS SH_DISPLAY                        FROM V_CURR_OBJ_STAKEHOLDERS                       WHERE CODE = 'SUPPORT') SH2              ON I.OBJ = SH2.OBJ
TEXT_VC SELECT DISTINCT           I.SID,           I.OBJ,           I.ID,           I.SUBJECT TITLE,           OT.DISPLAY OBJ_TYPE,           C.DISPLAY ALLEGATION_CATEGORY,           SC.DISPLAY ALLEGATION_SUBCATEGORY,           F.DISPLAY CONTRIBUTING_FACTOR,           I.POLICY_VIOLATION POLICY_REVIEW,           IR.DISPLAY CASE_DISPOSITION,           I.AGENCY_CASE_NUM,           I.INV_AUTHORIZATION,           SUB.SUBJECTS,           OA.OWNING_AGENCY,           STAT1.STATUS,           TRUNC (STAT2.STARTED_ON) OPEN_DATE,           STAT2.STARTED_ON_FY OPEN_DATE_FY,           TRUNC(STAT6.STARTED_ON) OVERALL_CLOSED_DATE,           TRUNC (STAT3.STARTED_ON) CLOSED_DATE,           STAT3.STARTED_ON_FY CLOSED_DATE_FY,           TRUNC(STAT5.STARTED_ON) CLOSED_NI_DATE,           STAT5.STARTED_ON_FY CLOSED_NI_FY,   TRUNC (STAT4.STARTED_ON) INV_CLOSED_DATE,           STAT4.STARTED_ON_FY INV_CLOSED_DATE_FY,           (TRUNC (NVL (STAT6.STARTED_ON, SYSDATE)) - TRUNC (STAT2.STARTED_ON))              DAYS_OPEN,           SH1.SH_DISPLAY LEAD_PERSONNEL,           SH2.SH_DISPLAY SUPPORT_PERSONNEL,           I.INCIDENT_DATE,           I.INCIDENT_DATE_FY,   R1.DISPLAY INCIDENT_LOCATION,           I.REPORTED_DATE,           I.REPORTED_DATE_FY,           O.NEXT_DUE_DATE,           O.FINAL_DUE_DATE,           O.FINAL_DUE_DATE_FY,           CASE              WHEN TRUNC (STAT3.STARTED_ON) <= TRUNC (O.FINAL_DUE_DATE)              THEN                 'Yes'              ELSE                 'No'           END              FINAL_DUE_DATE_MET,           O.CREATED_ON CREATED_DATE,           O.CREATED_ON_FY CREATED_ON_FY,           O.LAST_MODIFIED_ON LAST_MODIFIED_DATE,          (TRUNC (NVL (STAT4.STARTED_ON, SYSDATE)) - TRUNC (O.CREATED_ON))              TIME_TO_INVESTIGATIVELY_CLOSED_DAYS,           SUB.OFFICE         FROM MV_F_INFORMATION I           INNER JOIN MV_ACM_OBJ O              ON I.OBJ = O.SID           INNER JOIN MV_ACM_OBJ_TYPE OT              ON O.OBJ_TYPE = OT.SID              AND OT.OBJ_TYPE_CODE != 'FILE.COLL_INV'           LEFT JOIN MV_INCIDENT_CATEGORIES SC              ON I.INCIDENT = SC.SID           LEFT JOIN MV_INCIDENT_CATEGORIES C              ON SC.PARENT_CATEGORY = C.SID           LEFT JOIN MV_CONTRIBUTING_FACTORS F              ON I.CONTRIBUTING_FACTOR = F.SID           LEFT JOIN MV_F_INFORMATION_REF IR              ON I.DISPOSITION = IR.REF_KEY           LEFT JOIN MV_ACM_REFERENCE R1             ON I.INCIDENT_LOCATION = R1.REF_KEY           LEFT JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (PARTIC_OBJ, ';' || CHR (13)) WITHIN GROUP (ORDER BY PARTIC_OBJ) OVER (PARTITION BY OBJ)                                AS SUBJECTS,                             LISTAGG(OFFICE,';' || CHR (13)) WITHIN GROUP ( ORDER BY PARTIC_OBJ ) OVER (PARTITION BY OBJ) AS OFFICE                        FROM V_OBJ_PARTICIPANTS                       WHERE CODE = 'SUBJECT') SUB              ON I.OBJ = SUB.OBJ           LEFT JOIN (SELECT DISTINCT                             OBJ,                             LISTAGG (PARTIC_DISPLAY, ';' || CHR (13))                                WITHIN GROUP (ORDER BY PARTIC_DISPLAY)                                OVER (PARTITION BY OBJ)                                AS OWNING_AGENCY                        FROM V_OBJ_PARTICIPANTS                       WHERE CODE = 'OWNING_AGENCY') OA              ON I.OBJ = OA.OBJ           LEFT JOIN V_OBJ_STATUS_HISTORY STAT1              ON I.OBJ = STAT1.OBJ AND STAT1.COMPLETED_ON IS NULL           LEFT JOIN (  SELECT OBJ,                               MIN (STARTED_ON) STARTED_ON,                               MIN (STARTED_ON_FY) STARTED_ON_FY                          FROM V_OBJ_STATUS_HISTORY                         WHERE CODE = 'OPEN'                      GROUP BY OBJ) STAT2              ON I.OBJ = STAT2.OBJ           LEFT JOIN V_OBJ_STATUS_HISTORY STAT3              ON I.OBJ = STAT3.OBJ AND STAT3.CODE LIKE 'CLOSED'   LEFT JOIN (  SELECT OBJ,          
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT